﻿CREATE PROCEDURE [Restaurant].[SP_DeliverySite_I]
	@DeliverySiteID int OUTPUT,
	@Name nvarchar(50),
	@Description nvarchar(200),
	@MaxTicketsPerLetter tinyint
AS
	INSERT INTO [Restaurant].[DeliverySite] (Name, [Description], MaxTicketsPerLetter)
	VALUES(@Name, @Description, @MaxTicketsPerLetter)

	SET @DeliverySiteID = SCOPE_IDENTITY()
RETURN 0